package cn.com.api.mapper.base;

import java.util.List;
import java.util.Map;

import org.apache.ibatis.annotations.*;

import cn.com.api.entity.ApiU_org;

//DAO
public interface U_orgMapperBase {

	// 根据id查看
	@Select("SELECT * FROM U_ORG  WHERE ID = #{id}")
	public ApiU_org findU_orgById(Integer id);

	// 查看数据集
	@Select("SELECT * FROM U_org")
	public List<ApiU_org> findU_orgs();

	// 添加
	public int insertU_org(ApiU_org u_org);

	// 修改
	@Update("UPDATE U_ORG SET CORP_CODE = #{corp_code}, CUR_INDEX = #{cur_index}, CORP_FNAME = #{corp_fname}, CORP_SNAME = #{corp_sname}, BELONG = #{belong}, ADDRESS = #{address}, CORP_SIZE = #{corp_size}, URL = #{url}, LOGO = #{logo}, DESCRIPTION = #{description}, BACK_IMG = #{back_img}, EXT1 = #{ext1}, EXT2 = #{ext2}, EXT3 = #{ext3}, EXT4 = #{ext4}, EXT5 = #{ext5} WHERE ID = #{id}")
	public int updateU_org(ApiU_org u_org);

	// 删除
	@Delete("DELETE FROM U_ORG  WHERE ID = #{id}")
	public int deleteU_org(Integer id);

	// Foreign keys revelant

	// region Indexs revelant

}
